Create Worksheet

Command Prototype

Excel.CreateSheet(objExcelWorkBook,strSheetName,strWhere,bSave)

Command Description

Create a sheet, insert it before or after the currently active sheet, and activate the sheet after the creation is completed

Parameter Description

Required Parameter

objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel))

strSheetName--Name of the new created worksheet

strWhere--The sheet used as a location reference when creating a sheet

bSave--Save immediately after an operation